- 首页列表显示全部问答:
- 将数据库查询结果传递到前端页面 Question.query.all()
- 前端页面循环显示整个列表。
- 问答排序
- 完成问答详情页布局:
- 包含问答的全部信息
- 评论区
- 以往评论列表显示区。
- 在首页点击问答标题,链接到相应详情页。
from flask import Flask,render_template,request,redirect,url_for,sessionfrom flask import Flaskfrom flask_sqlalchemy import SQLAlchemyimport configfrom functools import wrapsfrom datetime import datetimeapp = Flask(__name__)#app.config['SECRET_KEY'] = '1234567'app.config.from_object(config)db = SQLAlchemy(app)class User(db.Model): __tablename__ = 'user_test' id=db.Column(db.Integer,primary_key=True,autoincrement=True) username=db.Column(db.String(20),nullable=False) password = db.Column(db.String(20), nullable=False) nickname = db.Column(db.String(20)) tel = db.Column(db.String(20))class Question(db.Model): __tablename__ = 'question' id=db.Column(db.Integer,primary_key=True,autoincrement=True) title = db.Column(db.String(100),nullable=False) detail = db.Column(db.Text,nullable=False) creat_time = db.Column(db.DateTime,default=datetime.now) author_id = db.Column(db.Integer,db.ForeignKey('user_test.id')) author = db.relationship('User',backref=db.backref('question'))# db.create_all()#2.在表中插入一条记录#user = User(username = 'mis1',password = '124', nickname='wk')#db.session.add(user)#db.session.commit()#3.去表中查询用户名对应的密码和接下来用户输入的密码是否相匹配#user = User.query.filter(User.username == 'mis1234').first()#print(user)#print(user.id,user.username)#输出查找到的用户名的id,密码等.#修改查询到的用户名的密码等#user = User.query.filter(User.username == 'mis1234').first()#user.password = '123'#db.session.commit()#再次插入一条记录# user = User(username = 'wkkkkkk',password = '123456', nickname='kk')# db.session.add(user)# db.session.commit()#删除一条记录#user = User.query.filter(User.username == 'mis1234').first()#db.session.delete(user)#db.session.commit()@app.route('/')def index(): context={ 'questions':Question.query.all() } return render_template('index.html',**context)@app.route('/detail/
')def detail(question_id): return render_template('detail.html',ques = question_id)@app.route('/login/',methods=['GET','POST'])def login(): if request.method == 'GET': return render_template('login.html') else: usern = request.form.get('uname') passw = request.form.get('upass') user = User.query.filter(User.username==usern).first() if user: if user.password == passw: session['user'] = usern; return redirect(url_for('index')) else: return 'password error!' else: return 'username is not exister!'@app.route('/register/',methods=['GET','POST'])def register(): if request.method =='GET': return render_template('register.html') else: usern = request.form.get('uname') teln = request.form.get('number') passw = request.form.get('upass') user = User.query.filter(User.username==usern).first() if user: return 'username existed' else: user1= User(username=usern,tel=teln,password=passw) db.session.add(user1) db.session.commit() return redirect(url_for('login'))@app.context_processordef mycontext(): usern = session.get('user') if usern: return{ 'username':usern} else: return {}def loginFirst(func): @wraps(func) def wrapper(*args,** kwargs): if session.get('user'): return func(*args,** kwargs) else: return redirect(url_for('login')) return wrapper@app.route('/logout/')def logout(): session.clear() return redirect(url_for('index'))@app.route('/question/',methods=['GET','POST'])@loginFirstdef question(): if request.method =='GET': return render_template('question.html') else: biaoti = request.form.get('biaoti') detail = request.form.get('detail') author_id = User.query.filter(User.username==session.get('user')).first().id question = Question(title=biaoti,detail=detail,author_id=author_id) db.session.add(question) db.session.commit() return redirect(url_for('index'))@app.route('/questionDetail/')def questionDetail(): return render_template('questionDetail.html')if __name__ == '__main__': app.run(debug=True) 首页 {#login#}{#register#}{#question#}{
{ username }}context- {% for foo in questions %}
- { { foo.author.username }} { { foo.title }} { { foo.creat_time }}
{
{ foo.detail}} {% endfor %}
问答详情页 {#login#}{#register#}{#question#}{
{ username }}context评论:{#- username
detail
- #}{# {% for foo in questions %}#}{#
- #}{# #}{# { { foo.author.username }}#}{# #}{# { { foo.title }}#}{# { { foo.creat_time }}#}{#
{
{ foo.detail}}#}{# #}{# {% endfor %}#}{#
- { { foo.author.username }} { { foo.title }} { { foo.creat_time }}